Re: Vacuum as "easily obtained" locks

At 19:32 03/08/2011, you wrote:
>On 08/03/11 10:21 AM, Eduardo Morras wrote:
>>One question, while you run your tests, does "IDLE IN TRANSACTION"
>>messages happen? If you run your tests with a permanent connection
>>to database, the tables are locked and autovacuum cannot work.
>
>its not that tables are locked, its that vacuum (auto or otherwise)
>can't clear any tuples newer than the oldest active transaction.

Yes, this is what happened to me 2-3 years ago. Table had only 1-3
rows but its size is 80-90 Gb. Once the app quits, autovacuum cleaned
the table and became 8KB